<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title> INFORMATION_SCHEMA Index</title>
<link rel="stylesheet" href="mvl.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets + chunker.py v1.9.2" />
<link rel="start" href="index.html" title="{book-title}" />
<link rel="up" href="" title="" />
<link rel="prev" href="dynindex-function.html" title=" Function Index" />
<link rel="next" href="dynindex-jointype.html" title=" Join Types Index" />
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center"> INFORMATION_SCHEMA Index</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="dynindex-function.html">Prev</a> </td>
<th width="60%" align="center"></th>
<td width="20%" align="right"> <a accesskey="n" href="dynindex-jointype.html">Next</a></td>
</tr>
</table>
<hr>
</div>
<div class="index">

<div class="titlepage">
<div>
<div>
<h2 class="title"><a name="dynindex-is"></a>INFORMATION_SCHEMA Index</h2>

</div>

</div>

</div>
<p><a name="is-index-top"></a><a class="link" href="dynindex-is.html#is-index-C" title="C">C</a> | <a class="link" href="dynindex-is.html#is-index-E" title="E">E</a> | <a class="link" href="dynindex-is.html#is-index-F" title="F">F</a> | <a class="link" href="dynindex-is.html#is-index-I" title="I">I</a> | <a class="link" href="dynindex-is.html#is-index-K" title="K">K</a> | <a class="link" href="dynindex-is.html#is-index-N" title="N">N</a> | <a class="link" href="dynindex-is.html#is-index-O" title="O">O</a> | <a class="link" href="dynindex-is.html#is-index-P" title="P">P</a> | <a class="link" href="dynindex-is.html#is-index-R" title="R">R</a> | <a class="link" href="dynindex-is.html#is-index-S" title="S">S</a> | <a class="link" href="dynindex-is.html#is-index-T" title="T">T</a> | <a class="link" href="dynindex-is.html#is-index-U" title="U">U</a> | <a class="link" href="dynindex-is.html#is-index-V" title="V">V</a></p>
<div class="indexdiv">
<a name="is-index-C"></a><h3 class="title">C</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHARACTER_SETS</h3>
<dl><dt><a class="xref" href="charset.html#charset-introducer" title="10.3.8 Character Set Introducers">Section 10.3.8, “Character Set Introducers”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-mysql" title="10.2 Character Sets and Collations in MySQL">Section 10.2, “Character Sets and Collations in MySQL”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-literal" title="10.3.6 Character String Literal Character Set and Collation">Section 10.3.6, “Character String Literal Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-column" title="10.3.5 Column Character Set and Collation">Section 10.3.5, “Column Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-database" title="10.3.3 Database Character Set and Collation">Section 10.3.3, “Database Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-character-set" title="13.7.7.3 SHOW CHARACTER SET Statement">Section 13.7.7.3, “SHOW CHARACTER SET Statement”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-charsets" title="10.10 Supported Character Sets and Collations">Section 10.10, “Supported Character Sets and Collations”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-table" title="10.3.4 Table Character Set and Collation">Section 10.3.4, “Table Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#character-sets-table" title="25.4 The INFORMATION_SCHEMA CHARACTER_SETS Table">Section 25.4, “The INFORMATION_SCHEMA CHARACTER_SETS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">CHECK_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#check-constraints-table" title="25.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table">Section 25.5, “The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLLATION_CHARACTER_SET_APPLICABILITY</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#information-schema-optimization" title="8.2.3 Optimizing INFORMATION_SCHEMA Queries">Section 8.2.3, “Optimizing INFORMATION_SCHEMA Queries”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#collation-character-set-applicability-table" title="25.7 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table">Section 25.7, “The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLLATIONS</h3>
<dl><dt><a class="xref" href="connectors-apis.html#c-api-data-structures" title="28.7.4 C API Data Structures">Section 28.7.4, “C API Data Structures”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-configuration" title="10.15 Character Set Configuration">Section 10.15, “Character Set Configuration”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-mysql" title="10.2 Character Sets and Collations in MySQL">Section 10.2, “Character Sets and Collations in MySQL”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-collation" title="13.7.7.4 SHOW COLLATION Statement">Section 13.7.7.4, “SHOW COLLATION Statement”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-binary-collations" title="10.8.5 The binary Collation Compared to _bin Collations">Section 10.8.5, “The binary Collation Compared to _bin Collations”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#char" title="11.3.2 The CHAR and VARCHAR Types">Section 11.3.2, “The CHAR and VARCHAR Types”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#collations-table" title="25.6 The INFORMATION_SCHEMA COLLATIONS Table">Section 25.6, “The INFORMATION_SCHEMA COLLATIONS Table”</a></dt><dd></dd><dt><a class="xref" href="charset.html#charset-unicode-sets" title="10.10.1 Unicode Character Sets">Section 10.10.1, “Unicode Character Sets”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMN_PRIVILEGES</h3>
<dl><dt><a class="xref" href="information-schema.html#column-privileges-table" title="25.9 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table">Section 25.9, “The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMN_STATISTICS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimizer-statistics" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#column-statistics-table" title="25.10 The INFORMATION_SCHEMA COLUMN_STATISTICS Table">Section 25.10, “The INFORMATION_SCHEMA COLUMN_STATISTICS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-columns" title="13.7.7.5 SHOW COLUMNS Statement">Section 13.7.7.5, “SHOW COLUMNS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#columns-table" title="25.8 The INFORMATION_SCHEMA COLUMNS Table">Section 25.8, “The INFORMATION_SCHEMA COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-page-table" title="25.46.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">Section 25.46.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-page-lru-table" title="25.46.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.46.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-pool-stats-table" title="25.46.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table">Section 25.46.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cached-indexes-table" title="25.46.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.46.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmp-table" title="25.46.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.46.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmp-per-index-table" title="25.46.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.46.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmpmem-table" title="25.46.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.46.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-columns-table" title="25.46.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table">Section 25.46.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-datafiles-table" title="25.46.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.46.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-fields-table" title="25.46.10 The INFORMATION_SCHEMA INNODB_FIELDS Table">Section 25.46.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-foreign-table" title="25.46.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table">Section 25.46.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-foreign-cols-table" title="25.46.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">Section 25.46.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-being-deleted-table" title="25.46.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.46.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-config-table" title="25.46.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">Section 25.46.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-default-stopword-table" title="25.46.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">Section 25.46.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-deleted-table" title="25.46.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.46.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-index-cache-table" title="25.46.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table">Section 25.46.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-index-table-table" title="25.46.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table">Section 25.46.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-indexes-table" title="25.46.19 The INFORMATION_SCHEMA INNODB_INDEXES Table">Section 25.46.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-metrics-table" title="25.46.22 The INFORMATION_SCHEMA INNODB_METRICS Table">Section 25.46.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-session-temp-tablespaces-table" title="25.46.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">Section 25.46.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tables-table" title="25.46.24 The INFORMATION_SCHEMA INNODB_TABLES Table">Section 25.46.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-table" title="25.46.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.46.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-brief-table" title="25.46.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.46.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablestats-table" title="25.46.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View">Section 25.46.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-temp-table-info-table" title="25.46.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table">Section 25.46.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-trx-table" title="25.46.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.46.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-virtual-table" title="25.46.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.46.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#st-geometry-columns-table" title="25.33 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">Section 25.33, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS</h3>
<dl><dt><a class="xref" href="security.html#connection-control-installation" title="6.4.2.1 Connection-Control Plugin Installation">Section 6.4.2.1, “Connection-Control Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="security.html#connection-control-variables" title="6.4.2.2 Connection-Control System and Status Variables">Section 6.4.2.2, “Connection-Control System and Status Variables”</a></dt><dd></dd><dt><a class="xref" href="security.html#connection-control" title="6.4.2 The Connection-Control Plugins">Section 6.4.2, “The Connection-Control Plugins”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#connection-control-failed-login-attempts-table" title="25.48.1 The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table">Section 25.48.1, “The INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-E"></a><h3 class="title">E</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ENGINES</h3>
<dl><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-sql-statements" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-engines" title="13.7.7.16 SHOW ENGINES Statement">Section 13.7.7.16, “SHOW ENGINES Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#engines-table" title="25.12 The INFORMATION_SCHEMA ENGINES Table">Section 25.12, “The INFORMATION_SCHEMA ENGINES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">EVENTS</h3>
<dl><dt><a class="xref" href="stored-objects.html#events-metadata" title="24.4.4 Event Metadata">Section 24.4.4, “Event Metadata”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#events-configuration" title="24.4.2 Event Scheduler Configuration">Section 24.4.2, “Event Scheduler Configuration”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-invoked" title="17.5.1.16 Replication of Invoked Features">Section 17.5.1.16, “Replication of Invoked Features”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-events" title="13.7.7.18 SHOW EVENTS Statement">Section 13.7.7.18, “SHOW EVENTS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#events-table" title="25.13 The INFORMATION_SCHEMA EVENTS Table">Section 25.13, “The INFORMATION_SCHEMA EVENTS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-F"></a><h3 class="title">F</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">FILES</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-i_s-tables" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-disk-data-objects" title="22.5.13.1 NDB Cluster Disk Data Objects">Section 22.5.13.1, “NDB Cluster Disk Data Objects”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-ndbinfo" title="22.5.10 ndbinfo: The NDB Cluster Information Database">Section 22.5.10, “ndbinfo: The NDB Cluster Information Database”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#files-table" title="25.14 The INFORMATION_SCHEMA FILES Table">Section 25.14, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-datafiles-table" title="25.46.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.46.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-table" title="25.46.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.46.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tablespaces-table" title="25.37 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.37, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-I"></a><h3 class="title">I</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA</h3>
<dl><dt><a class="xref" href="installing.html#upgrading-from-previous-series" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-schema" title="14.1 Data Dictionary Schema">Section 14.1, “Data Dictionary Schema”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-i_s-tables" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema" title="15.15 InnoDB INFORMATION_SCHEMA Tables">Section 15.15, “InnoDB INFORMATION_SCHEMA Tables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html" title="Chapter 14 MySQL Data Dictionary">Chapter 14, <i>MySQL Data Dictionary</i></a></dt><dd></dd><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="security.html#reserved-users" title="6.2.9 Reserved Accounts">Section 6.2.9, “Reserved Accounts”</a></dt><dd></dd><dt><a class="xref" href="error-handling.html#server-error-reference" title="B.3.1 Server Error Message Reference">Section B.3.1, “Server Error Message Reference”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#data-directory" title="5.2 The MySQL Data Directory">Section 5.2, “The MySQL Data Directory”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-schema-usage" title="27.2 Using the sys Schema">Section 27.2, “Using the sys Schema”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.CHARACTER_SETS</h3>
<dl><dt><a class="xref" href="faqs.html#faqs-cjk" title="A.11 MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets">Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean
Character Sets”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLLATIONS</h3>
<dl><dt><a class="xref" href="charset.html#adding-collation-choosing-id" title="10.14.2 Choosing a Collation ID">Section 10.14.2, “Choosing a Collation ID”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimizer-statistics" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLUMN_STATISTICS</h3>
<dl><dt><a class="xref" href="sql-statements.html#analyze-table" title="13.7.3.1 ANALYZE TABLE Statement">Section 13.7.3.1, “ANALYZE TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#optimizer-statistics" title="8.9.6 Optimizer Statistics">Section 8.9.6, “Optimizer Statistics”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.COLUMNS</h3>
<dl><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-programs-ndb-index-stat" title="22.4.14 ndb_index_stat — NDB Index Statistics Utility">Section 22.4.14, “<span class="command"><strong>ndb_index_stat</strong></span> — NDB Index Statistics Utility”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-quick-start" title="26.1 Performance Schema Quick Start">Section 26.1, “Performance Schema Quick Start”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="installing.html#upgrade-binary-package" title="2.11.6 Upgrading MySQL Binary or Package-based Installations on Unix/Linux">Section 2.11.6, “Upgrading MySQL Binary or Package-based Installations on Unix/Linux”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.ENGINES</h3>
<dl><dt><a class="xref" href="performance-schema.html#performance-schema-quick-start" title="26.1 Performance Schema Quick Start">Section 26.1, “Performance Schema Quick Start”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-sql-statements" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-check-availability" title="15.1.3 Verifying that InnoDB is the Default Storage Engine">Section 15.1.3, “Verifying that InnoDB is the Default Storage Engine”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.EVENTS</h3>
<dl><dt><a class="xref" href="stored-objects.html#events-metadata" title="24.4.4 Event Metadata">Section 24.4.4, “Event Metadata”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-features-invoked" title="17.5.1.16 Replication of Invoked Features">Section 17.5.1.16, “Replication of Invoked Features”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#stored-program-restrictions" title="24.8 Restrictions on Stored Programs">Section 24.8, “Restrictions on Stored Programs”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#events-privileges" title="24.4.6 The Event Scheduler and MySQL Privileges">Section 24.4.6, “The Event Scheduler and MySQL Privileges”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.FILES</h3>
<dl><dt><a class="xref" href="sql-statements.html#alter-logfile-group" title="13.1.6 ALTER LOGFILE GROUP Statement">Section 13.1.6, “ALTER LOGFILE GROUP Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#alter-tablespace" title="13.1.10 ALTER TABLESPACE Statement">Section 13.1.10, “ALTER TABLESPACE Statement”</a></dt><dd></dd><dt><a class="xref" href="installing.html#upgrading-from-previous-series" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#clone-plugin-remote" title="5.6.7.3 Cloning Remote Data">Section 5.6.7.3, “Cloning Remote Data”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-logfile-group" title="13.1.16 CREATE LOGFILE GROUP Statement">Section 13.1.16, “CREATE LOGFILE GROUP Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-tablespace" title="13.1.21 CREATE TABLESPACE Statement">Section 13.1.21, “CREATE TABLESPACE Statement”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-moving-data-files-offline" title="15.6.3.6 Moving Tablespace Files While the Server is Offline">Section 15.6.3.6, “Moving Tablespace Files While the Server is Offline”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-disk-data-storage-requirements" title="22.5.13.2 NDB Cluster Disk Data Storage Requirements">Section 22.5.13.2, “NDB Cluster Disk Data Storage Requirements”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-programs-ndb-desc" title="22.4.9 ndb_desc — Describe NDB Tables">Section 22.4.9, “<span class="command"><strong>ndb_desc</strong></span> — Describe NDB Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-files-table" title="15.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-temporary-tablespace" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-undo-tablespaces" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-what-is-new" title="22.1.4 What is New in NDB Cluster">Section 22.1.4, “What is New in NDB Cluster”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_BUFFER_PAGE</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-change-buffer" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CACHED_INDEXES</h3>
<dl><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMP</h3>
<dl><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-compression-tuning" title="15.9.1.3 Tuning Compression for InnoDB Tables">Section 15.9.1.3, “Tuning Compression for InnoDB Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples-compression-sect" title="15.15.1.3 Using the Compression Information Schema Tables">Section 15.15.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMP_PER_INDEX</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-compression-tuning" title="15.9.1.3 Tuning Compression for InnoDB Tables">Section 15.9.1.3, “Tuning Compression for InnoDB Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_CMPMEM</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples-compression-sect" title="15.15.1.3 Using the Compression Information Schema Tables">Section 15.15.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_COLUMNS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-online-ddl-operations" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_DATAFILES</h3>
<dl><dt><a class="xref" href="installing.html#upgrading-from-previous-series" title="2.11.4 Changes in MySQL 8.0">Section 2.11.4, “Changes in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_CONFIG</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD</h3>
<dl><dt><a class="xref" href="functions.html#fulltext-stopwords" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_INDEX_CACHE</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-search-mecab" title="12.9.9 MeCab Full-Text Parser Plugin">Section 12.9.9, “MeCab Full-Text Parser Plugin”</a></dt><dd></dd><dt><a class="xref" href="functions.html#fulltext-search-ngram" title="12.9.8 ngram Full-Text Parser">Section 12.9.8, “ngram Full-Text Parser”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_FT_INDEX_TABLE</h3>
<dl><dt><a class="xref" href="functions.html#fulltext-stopwords" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_INDEXES</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_METRICS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-change-buffer" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-metrics-table" title="15.15.6 InnoDB INFORMATION_SCHEMA Metrics Table">Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-undo-tablespaces" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLES</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-management-exchange" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-row-format" title="15.10 InnoDB Row Formats">Section 15.10, “InnoDB Row Formats”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-online-ddl-operations" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESPACES</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-data-encryption" title="15.13 InnoDB Data-at-Rest Encryption">Section 15.13, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-page-compression" title="15.9.2 InnoDB Page Compression">Section 15.9.2, “InnoDB Page Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-undo-tablespaces" title="15.6.3.4 Undo Tablespaces">Section 15.6.3.4, “Undo Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF</h3>
<dl><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TABLESTATS</h3>
<dl><dt><a class="xref" href="sql-statements.html#analyze-table" title="13.7.3.1 ANALYZE TABLE Statement">Section 13.7.3.1, “ANALYZE TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TEMP_TABLE_INFO</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-temporary-tablespace" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.INNODB_TRX</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-transaction-scheduling" title="15.7.6 Transaction Scheduling">Section 15.7.6, “Transaction Scheduling”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.KEY_COLUMN_USAGE</h3>
<dl><dt><a class="xref" href="introduction.html#constraint-foreign-key" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-table-foreign-keys" title="13.1.20.5 FOREIGN KEY Constraints">Section 13.1.20.5, “FOREIGN KEY Constraints”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.OPTIMIZER_TRACE</h3>
<dl><dt><a class="xref" href="optimization.html#range-optimization" title="8.2.1.2 Range Optimization">Section 8.2.1.2, “Range Optimization”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PARTITIONS</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-management-exchange" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-handling-nulls" title="23.2.7 How MySQL Partitioning Handles NULL">Section 23.2.7, “How MySQL Partitioning Handles NULL”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-key" title="23.2.5 KEY Partitioning">Section 23.2.5, “KEY Partitioning”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-info" title="23.3.5 Obtaining Information About Partitions">Section 23.3.5, “Obtaining Information About Partitions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-columns-range" title="23.2.3.1 RANGE COLUMNS partitioning">Section 23.2.3.1, “RANGE COLUMNS partitioning”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PLUGINS</h3>
<dl><dt><a class="xref" href="server-administration.html#clone-plugin-remote" title="5.6.7.3 Cloning Remote Data">Section 5.6.7.3, “Cloning Remote Data”</a></dt><dd></dd><dt><a class="xref" href="security.html#connection-control-installation" title="6.4.2.1 Connection-Control Plugin Installation">Section 6.4.2.1, “Connection-Control Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-data-encryption" title="15.13 InnoDB Data-at-Rest Encryption">Section 15.13, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#plugin-loading" title="5.6.1 Installing and Uninstalling Plugins">Section 5.6.1, “Installing and Uninstalling Plugins”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#ddl-rewriter-installation" title="5.6.5.1 Installing or Uninstalling ddl_rewriter">Section 5.6.5.1, “Installing or Uninstalling ddl_rewriter”</a></dt><dd></dd><dt><a class="xref" href="security.html#audit-log-installation" title="6.4.5.2 Installing or Uninstalling MySQL Enterprise Audit">Section 6.4.5.2, “Installing or Uninstalling MySQL Enterprise Audit”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#clone-plugin-installation" title="5.6.7.1 Installing the Clone Plugin">Section 5.6.7.1, “Installing the Clone Plugin”</a></dt><dd></dd><dt><a class="xref" href="security.html#keyring-installation" title="6.4.4.1 Keyring Plugin Installation">Section 6.4.4.1, “Keyring Plugin Installation”</a></dt><dd></dd><dt><a class="xref" href="security.html#ldap-pluggable-authentication" title="6.4.1.7 LDAP Pluggable Authentication">Section 6.4.1.7, “LDAP Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-storage-engines" title="A.2 MySQL 8.0 FAQ: Storage Engines">Section A.2, “MySQL 8.0 FAQ: Storage Engines”</a></dt><dd></dd><dt><a class="xref" href="security.html#no-login-pluggable-authentication" title="6.4.1.8 No-Login Pluggable Authentication">Section 6.4.1.8, “No-Login Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#obtaining-plugin-information" title="5.6.2 Obtaining Server Plugin Information">Section 5.6.2, “Obtaining Server Plugin Information”</a></dt><dd></dd><dt><a class="xref" href="security.html#pam-pluggable-authentication" title="6.4.1.5 PAM Pluggable Authentication">Section 6.4.1.5, “PAM Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#plugin-api-characteristics" title="29.2.2 Plugin API Characteristics">Section 29.2.2, “Plugin API Characteristics”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#plugin-api-components" title="29.2.3 Plugin API Components">Section 29.2.3, “Plugin API Components”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-sql-statements" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="replication.html#replication-semisync-installation" title="17.4.9.2 Semisynchronous Replication Installation and Configuration">Section 17.4.9.2, “Semisynchronous Replication Installation and Configuration”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#server-plugin-descriptors" title="29.2.4.2.1 Server Plugin Library and Plugin Descriptors">Section 29.2.4.2.1, “Server Plugin Library and Plugin Descriptors”</a></dt><dd></dd><dt><a class="xref" href="security.html#socket-pluggable-authentication" title="6.4.1.9 Socket Peer-Credential Pluggable Authentication">Section 6.4.1.9, “Socket Peer-Credential Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="security.html#test-pluggable-authentication" title="6.4.1.10 Test Pluggable Authentication">Section 6.4.1.10, “Test Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#thread-pool-installation" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd><dt><a class="xref" href="security.html#windows-pluggable-authentication" title="6.4.1.6 Windows Pluggable Authentication">Section 6.4.1.6, “Windows Pluggable Authentication”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-audit-plugins" title="29.2.4.8 Writing Audit Plugins">Section 29.2.4.8, “Writing Audit Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-daemon-plugins" title="29.2.4.5 Writing Daemon Plugins">Section 29.2.4.5, “Writing Daemon Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-full-text-plugins" title="29.2.4.4 Writing Full-Text Parser Plugins">Section 29.2.4.4, “Writing Full-Text Parser Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-information-schema-plugins" title="29.2.4.6 Writing INFORMATION_SCHEMA Plugins">Section 29.2.4.6, “Writing INFORMATION_SCHEMA Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-keyring-plugins" title="29.2.4.12 Writing Keyring Plugins">Section 29.2.4.12, “Writing Keyring Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-password-validation-plugins" title="29.2.4.10 Writing Password-Validation Plugins">Section 29.2.4.10, “Writing Password-Validation Plugins”</a></dt><dd></dd><dt><a class="xref" href="extending-mysql.html#writing-authentication-plugins-server-side" title="29.2.4.9.1 Writing the Server-Side Authentication Plugin">Section 29.2.4.9.1, “Writing the Server-Side Authentication Plugin”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.PROCESSLIST</h3>
<dl><dt><a class="xref" href="optimization.html#thread-information" title="8.14 Examining Thread Information">Section 8.14, “Examining Thread Information”</a></dt><dd></dd><dt><a class="xref" href="functions.html#information-functions" title="12.15 Information Functions">Section 12.15, “Information Functions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-instrument-naming" title="26.6 Performance Schema Instrument Naming Conventions">Section 26.6, “Performance Schema Instrument Naming Conventions”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#performance-schema-stage-tables" title="26.12.5 Performance Schema Stage Event Tables">Section 26.12.5, “Performance Schema Stage Event Tables”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#threads-table" title="26.12.19.5 The threads Table">Section 26.12.19.5, “The threads Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.RESOURCE_GROUPS</h3>
<dl><dt><a class="xref" href="server-administration.html#resource-groups" title="5.1.15 Resource Groups">Section 5.1.15, “Resource Groups”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.ROUTINES</h3>
<dl><dt><a class="xref" href="faqs.html#faqs-stored-procs" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd><dt><a class="xref" href="security.html#privileges-provided" title="6.2.2 Privileges Provided by MySQL">Section 6.2.2, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#stored-routines-privileges" title="24.2.2 Stored Routines and MySQL Privileges">Section 24.2.2, “Stored Routines and MySQL Privileges”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.SCHEMATA</h3>
<dl><dt><a class="xref" href="charset.html#charset-database" title="10.3.3 Database Character Set and Collation">Section 10.3.3, “Database Character Set and Collation”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-data-encryption" title="15.13 InnoDB Data-at-Rest Encryption">Section 15.13, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.STATISTICS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-statistics-estimation" title="15.8.10.2 Configuring Non-Persistent Optimizer Statistics Parameters">Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#index-hints" title="8.9.4 Index Hints">Section 8.9.4, “Index Hints”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#invisible-indexes" title="8.3.12 Invisible Indexes">Section 8.3.12, “Invisible Indexes”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-programs-ndb-index-stat" title="22.4.14 ndb_index_stat — NDB Index Statistics Utility">Section 22.4.14, “<span class="command"><strong>ndb_index_stat</strong></span> — NDB Index Statistics Utility”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#system-schema" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TABLE_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-online-ddl-operations" title="15.12.1 Online DDL Operations">Section 15.12.1, “Online DDL Operations”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TABLES</h3>
<dl><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-online-add-node-example" title="22.5.15.3 Adding NDB Cluster Data Nodes Online: Detailed Example">Section 22.5.15.3, “Adding NDB Cluster Data Nodes Online: Detailed Example”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#alter-table" title="13.1.9 ALTER TABLE Statement">Section 13.1.9, “ALTER TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-statistics-estimation" title="15.8.10.2 Configuring Non-Persistent Optimizer Statistics Parameters">Section 15.8.10.2, “Configuring Non-Persistent Optimizer Statistics Parameters”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-data-encryption" title="15.13 InnoDB Data-at-Rest Encryption">Section 15.13, “InnoDB Data-at-Rest Encryption”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-page-compression" title="15.9.2 InnoDB Page Compression">Section 15.9.2, “InnoDB Page Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-file-removal" title="14.2 Removal of File-based Metadata Storage">Section 14.2, “Removal of File-based Metadata Storage”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-diagnostics" title="27.4.4.2 The diagnostics() Procedure">Section 27.4.4.2, “The diagnostics() Procedure”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-sys-config" title="27.4.2.1 The sys_config Table">Section 27.4.2.1, “The sys_config Table”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#thread-pool-installation" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.TRIGGERS</h3>
<dl><dt><a class="xref" href="faqs.html#faqs-triggers" title="A.5 MySQL 8.0 FAQ: Triggers">Section A.5, “MySQL 8.0 FAQ: Triggers”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.USER_ATTRIBUTES</h3>
<dl><dt><a class="xref" href="sql-statements.html#alter-user" title="13.7.1.1 ALTER USER Statement">Section 13.7.1.1, “ALTER USER Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-user" title="13.7.1.3 CREATE USER Statement">Section 13.7.1.3, “CREATE USER Statement”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INFORMATION_SCHEMA.VIEWS</h3>
<dl><dt><a class="xref" href="installing.html#upgrade-prerequisites" title="2.11.5 Preparing Your Installation for Upgrade">Section 2.11.5, “Preparing Your Installation for Upgrade”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#view-updatability" title="24.5.3 Updatable and Insertable Views">Section 24.5.3, “Updatable and Insertable Views”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_PAGE</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-change-buffer" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-buffer-pool-tables" title="15.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-schema-prerequisites" title="27.1 Prerequisites for Using the sys Schema">Section 27.1, “Prerequisites for Using the sys Schema”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-page-table" title="25.46.1 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table">Section 25.46.1, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-page-lru-table" title="25.46.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.46.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-innodb-buffer-stats-by-schema" title="27.4.3.7 The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema Views">Section 27.4.3.7, “The innodb_buffer_stats_by_schema and x$innodb_buffer_stats_by_schema
          Views”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-innodb-buffer-stats-by-table" title="27.4.3.8 The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table Views">Section 27.4.3.8, “The innodb_buffer_stats_by_table and x$innodb_buffer_stats_by_table
Views”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_PAGE_LRU</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-buffer-pool-tables" title="15.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-preload-buffer-pool" title="15.8.3.6 Saving and Restoring the Buffer Pool State">Section 15.8.3.6, “Saving and Restoring the Buffer Pool State”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-page-lru-table" title="25.46.2 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table">Section 25.46.2, “The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_BUFFER_POOL_STATS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-buffer-pool" title="15.5.1 Buffer Pool">Section 15.5.1, “Buffer Pool”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-buffer-pool-tables" title="15.15.5 InnoDB INFORMATION_SCHEMA Buffer Pool Tables">Section 15.15.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-buffer-pool-stats-table" title="25.46.3 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table">Section 25.46.3, “The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CACHED_INDEXES</h3>
<dl><dt><a class="xref" href="information-schema.html#innodb-cached-indexes-table" title="25.46.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.46.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-compression-tables" title="15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmp" title="15.15.1.1 INNODB_CMP and INNODB_CMP_RESET">Section 15.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmpmem" title="15.15.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-compression-tuning-monitoring" title="15.9.1.4 Monitoring InnoDB Table Compression at Runtime">Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmp-table" title="25.46.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.46.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples-compression-sect" title="15.15.1.3 Using the Compression Information Schema Tables">Section 15.15.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_PER_INDEX</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-compression-tuning-monitoring" title="15.9.1.4 Monitoring InnoDB Table Compression at Runtime">Section 15.9.1.4, “Monitoring InnoDB Table Compression at Runtime”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmp-per-index-table" title="25.46.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.46.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples-compression-sect" title="15.15.1.3 Using the Compression Information Schema Tables">Section 15.15.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_PER_INDEX_RESET</h3>
<dl><dt><a class="xref" href="information-schema.html#innodb-cmp-per-index-table" title="25.46.7 The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables">Section 25.46.7, “The INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and
INNODB_CMP_PER_INDEX_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMP_RESET</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-compression-tables" title="15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmp" title="15.15.1.1 INNODB_CMP and INNODB_CMP_RESET">Section 15.15.1.1, “INNODB_CMP and INNODB_CMP_RESET”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmpmem" title="15.15.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmp-table" title="25.46.5 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables">Section 25.46.5, “The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMPMEM</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-compression-tables" title="15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmpmem" title="15.15.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmpmem-table" title="25.46.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.46.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples-compression-sect" title="15.15.1.3 Using the Compression Information Schema Tables">Section 15.15.1.3, “Using the Compression Information Schema Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_CMPMEM_RESET</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-compression-tables" title="15.15.1 InnoDB INFORMATION_SCHEMA Tables about Compression">Section 15.15.1, “InnoDB INFORMATION_SCHEMA Tables about Compression”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-innodb_cmpmem" title="15.15.1.2 INNODB_CMPMEM and INNODB_CMPMEM_RESET">Section 15.15.1.2, “INNODB_CMPMEM and INNODB_CMPMEM_RESET”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cmpmem-table" title="25.46.6 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables">Section 25.46.6, “The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-columns-table" title="25.46.8 The INFORMATION_SCHEMA INNODB_COLUMNS Table">Section 25.46.8, “The INFORMATION_SCHEMA INNODB_COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-virtual-table" title="25.46.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.46.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_DATAFILES</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-files-table" title="15.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#files-table" title="25.14 The INFORMATION_SCHEMA FILES Table">Section 25.14, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-datafiles-table" title="25.46.9 The INFORMATION_SCHEMA INNODB_DATAFILES Table">Section 25.46.9, “The INFORMATION_SCHEMA INNODB_DATAFILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-brief-table" title="25.46.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.46.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tablespaces-table" title="25.37 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.37, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FIELDS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-fields-table" title="25.46.10 The INFORMATION_SCHEMA INNODB_FIELDS Table">Section 25.46.10, “The INFORMATION_SCHEMA INNODB_FIELDS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FOREIGN</h3>
<dl><dt><a class="xref" href="introduction.html#constraint-foreign-key" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-table-foreign-keys" title="13.1.20.5 FOREIGN KEY Constraints">Section 13.1.20.5, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-foreign-table" title="25.46.11 The INFORMATION_SCHEMA INNODB_FOREIGN Table">Section 25.46.11, “The INFORMATION_SCHEMA INNODB_FOREIGN Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FOREIGN_COLS</h3>
<dl><dt><a class="xref" href="introduction.html#constraint-foreign-key" title="1.8.3.2 FOREIGN KEY Constraints">Section 1.8.3.2, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-table-foreign-keys" title="13.1.20.5 FOREIGN KEY Constraints">Section 13.1.20.5, “FOREIGN KEY Constraints”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-foreign-cols-table" title="25.46.12 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table">Section 25.46.12, “The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_BEING_DELETED</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-being-deleted-table" title="25.46.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.46.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_CONFIG</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-config-table" title="25.46.14 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table">Section 25.46.14, “The INFORMATION_SCHEMA INNODB_FT_CONFIG Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_DEFAULT_STOPWORD</h3>
<dl><dt><a class="xref" href="functions.html#fulltext-stopwords" title="12.9.4 Full-Text Stopwords">Section 12.9.4, “Full-Text Stopwords”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-default-stopword-table" title="25.46.15 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">Section 25.46.15, “The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_DELETED</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-being-deleted-table" title="25.46.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.46.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-deleted-table" title="25.46.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.46.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_INDEX_CACHE</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-index-cache-table" title="25.46.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table">Section 25.46.17, “The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_FT_INDEX_TABLE</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-fulltext_index-tables" title="15.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">Section 15.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-parameters" title="15.14 InnoDB Startup Options and System Variables">Section 15.14, “InnoDB Startup Options and System Variables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-being-deleted-table" title="25.46.13 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table">Section 25.46.13, “The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-deleted-table" title="25.46.16 The INFORMATION_SCHEMA INNODB_FT_DELETED Table">Section 25.46.16, “The INFORMATION_SCHEMA INNODB_FT_DELETED Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-ft-index-table-table" title="25.46.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table">Section 25.46.18, “The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_INDEXES</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#index-page-merge-threshold" title="15.8.11 Configuring the Merge Threshold for Index Pages">Section 15.8.11, “Configuring the Merge Threshold for Index Pages”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cached-indexes-table" title="25.46.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.46.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-indexes-table" title="25.46.19 The INFORMATION_SCHEMA INNODB_INDEXES Table">Section 25.46.19, “The INFORMATION_SCHEMA INNODB_INDEXES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_LOCK_WAITS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-transactions" title="15.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-understanding-innodb-locking" title="15.15.2.2 InnoDB Lock and Lock-Wait Information">Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-internal-data" title="15.15.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-lock-waits-table" title="25.46.21 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table">Section 25.46.21, “The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples" title="15.15.2.1 Using InnoDB Transaction and Locking Information">Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_LOCKS</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-transactions" title="15.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-understanding-innodb-locking" title="15.15.2.2 InnoDB Lock and Lock-Wait Information">Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-internal-data" title="15.15.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-locks-table" title="25.46.20 The INFORMATION_SCHEMA INNODB_LOCKS Table">Section 25.46.20, “The INFORMATION_SCHEMA INNODB_LOCKS Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples" title="15.15.2.1 Using InnoDB Transaction and Locking Information">Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_METRICS</h3>
<dl><dt><a class="xref" href="sql-statements.html#analyze-table" title="13.7.3.1 ANALYZE TABLE Statement">Section 13.7.3.1, “ANALYZE TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-change-buffer" title="15.5.2 Change Buffer">Section 15.5.2, “Change Buffer”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#index-page-merge-threshold" title="15.8.11 Configuring the Merge Threshold for Index Pages">Section 15.8.11, “Configuring the Merge Threshold for Index Pages”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-metrics-table" title="15.15.6 InnoDB INFORMATION_SCHEMA Metrics Table">Section 15.15.6, “InnoDB INFORMATION_SCHEMA Metrics Table”</a></dt><dd></dd><dt><a class="xref" href="glossary.html" title="MySQL Glossary">MySQL Glossary</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-metrics-table" title="25.46.22 The INFORMATION_SCHEMA INNODB_METRICS Table">Section 25.46.22, “The INFORMATION_SCHEMA INNODB_METRICS Table”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-metrics" title="27.4.3.21 The metrics View">Section 27.4.3.21, “The metrics View”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-transaction-scheduling" title="15.7.6 Transaction Scheduling">Section 15.7.6, “Transaction Scheduling”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_SESSION_TEMP_TABLESPACES</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-temporary-tablespace" title="15.6.3.5 Temporary Tablespaces">Section 15.6.3.5, “Temporary Tablespaces”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-session-temp-tablespaces-table" title="25.46.23 The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table">Section 25.46.23, “The INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLES</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-fulltext-index" title="15.6.2.4 InnoDB FULLTEXT Indexes">Section 15.6.2.4, “InnoDB FULLTEXT Indexes”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-cached-indexes-table" title="25.46.4 The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table">Section 25.46.4, “The INFORMATION_SCHEMA INNODB_CACHED_INDEXES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tables-table" title="25.46.24 The INFORMATION_SCHEMA INNODB_TABLES Table">Section 25.46.24, “The INFORMATION_SCHEMA INNODB_TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESPACES</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-files-table" title="15.15.8 Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES">Section 15.15.8, “Retrieving InnoDB Tablespace Metadata from INFORMATION_SCHEMA.FILES”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-table-status" title="13.7.7.36 SHOW TABLE STATUS Statement">Section 13.7.7.36, “SHOW TABLE STATUS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#files-table" title="25.14 The INFORMATION_SCHEMA FILES Table">Section 25.14, “The INFORMATION_SCHEMA FILES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-table" title="25.46.25 The INFORMATION_SCHEMA INNODB_TABLESPACES Table">Section 25.46.25, “The INFORMATION_SCHEMA INNODB_TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-brief-table" title="25.46.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.46.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tables-table" title="25.36 The INFORMATION_SCHEMA TABLES Table">Section 25.36, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tablespaces-table" title="25.37 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.37, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd><dt><a class="xref" href="introduction.html#mysql-nutshell" title="1.4 What Is New in MySQL 8.0">Section 1.4, “What Is New in MySQL 8.0”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESPACES_BRIEF</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablespaces-brief-table" title="25.46.26 The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table">Section 25.46.26, “The INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TABLESTATS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-system-tables" title="15.15.3 InnoDB INFORMATION_SCHEMA Schema Object Tables">Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-tablestats-table" title="25.46.27 The INFORMATION_SCHEMA INNODB_TABLESTATS View">Section 25.46.27, “The INFORMATION_SCHEMA INNODB_TABLESTATS View”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TEMP_TABLE_INFO</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-temp-table-info" title="15.15.7 InnoDB INFORMATION_SCHEMA Temporary Table Info Table">Section 15.15.7, “InnoDB INFORMATION_SCHEMA Temporary Table Info Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-temp-table-info-table" title="25.46.28 The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table">Section 25.46.28, “The INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_TRX</h3>
<dl><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-transactions" title="15.15.2 InnoDB INFORMATION_SCHEMA Transaction and Locking Information">Section 15.15.2, “InnoDB INFORMATION_SCHEMA Transaction and Locking Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-understanding-innodb-locking" title="15.15.2.2 InnoDB Lock and Lock-Wait Information">Section 15.15.2.2, “InnoDB Lock and Lock-Wait Information”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-internal-data" title="15.15.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#data-locks-table" title="26.12.13.1 The data_locks Table">Section 26.12.13.1, “The data_locks Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-trx-table" title="25.46.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.46.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples" title="15.15.2.1 Using InnoDB Transaction and Locking Information">Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">INNODB_VIRTUAL</h3>
<dl><dt><a class="xref" href="information-schema.html#innodb-virtual-table" title="25.46.30 The INFORMATION_SCHEMA INNODB_VIRTUAL Table">Section 25.46.30, “The INFORMATION_SCHEMA INNODB_VIRTUAL Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-K"></a><h3 class="title">K</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">KEY_COLUMN_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#key-column-usage-table" title="25.15 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table">Section 25.15, “The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#system-schema" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">KEYWORDS</h3>
<dl><dt><a class="xref" href="information-schema.html#keywords-table" title="25.17 The INFORMATION_SCHEMA KEYWORDS Table">Section 25.17, “The INFORMATION_SCHEMA KEYWORDS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-N"></a><h3 class="title">N</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">NDB_TRANSID_MYSQL_CONNECTION_MAP</h3>
<dl><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-ndbinfo-server-operations" title="22.5.10.37 The ndbinfo server_operations Table">Section 22.5.10.37, “The ndbinfo server_operations Table”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-ndbinfo-server-transactions" title="22.5.10.38 The ndbinfo server_transactions Table">Section 22.5.10.38, “The ndbinfo server_transactions Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">ndb_transid_mysql_connection_map</h3>
<dl><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-i_s-tables" title="22.5.11 INFORMATION_SCHEMA Tables for NDB Cluster">Section 22.5.11, “INFORMATION_SCHEMA Tables for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-program-options-mysqld" title="22.3.3.9.1 MySQL Server Options for NDB Cluster">Section 22.3.3.9.1, “MySQL Server Options for NDB Cluster”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-ndbinfo" title="22.5.10 ndbinfo: The NDB Cluster Information Database">Section 22.5.10, “ndbinfo: The NDB Cluster Information Database”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-O"></a><h3 class="title">O</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">OPTIMIZER_TRACE</h3>
<dl><dt><a class="xref" href="information-schema.html#optimizer-trace-table" title="25.18 The INFORMATION_SCHEMA OPTIMIZER_TRACE Table">Section 25.18, “The INFORMATION_SCHEMA OPTIMIZER_TRACE Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<a name="is-index-P"></a><h3 class="title">P</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PARAMETERS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-stored-procs" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-procedure-status" title="13.7.7.28 SHOW PROCEDURE STATUS Statement">Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#parameters-table" title="25.19 The INFORMATION_SCHEMA PARAMETERS Table">Section 25.19, “The INFORMATION_SCHEMA PARAMETERS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#routines-table" title="25.29 The INFORMATION_SCHEMA ROUTINES Table">Section 25.29, “The INFORMATION_SCHEMA ROUTINES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PARTITIONS</h3>
<dl><dt><a class="xref" href="partitioning.html#partitioning-management-exchange" title="23.3.3 Exchanging Partitions and Subpartitions with Tables">Section 23.3.3, “Exchanging Partitions and Subpartitions with Tables”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-handling-nulls" title="23.2.7 How MySQL Partitioning Handles NULL">Section 23.2.7, “How MySQL Partitioning Handles NULL”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html#partitioning-info" title="23.3.5 Obtaining Information About Partitions">Section 23.3.5, “Obtaining Information About Partitions”</a></dt><dd></dd><dt><a class="xref" href="partitioning.html" title="Chapter 23 Partitioning">Chapter 23, <i>Partitioning</i></a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-table-status" title="13.7.7.36 SHOW TABLE STATUS Statement">Section 13.7.7.36, “SHOW TABLE STATUS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#partitions-table" title="25.20 The INFORMATION_SCHEMA PARTITIONS Table">Section 25.20, “The INFORMATION_SCHEMA PARTITIONS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tables-table" title="25.36 The INFORMATION_SCHEMA TABLES Table">Section 25.36, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PLUGINS</h3>
<dl><dt><a class="xref" href="sql-statements.html#install-plugin" title="13.7.4.4 INSTALL PLUGIN Statement">Section 13.7.4.4, “INSTALL PLUGIN Statement”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#obtaining-plugin-information" title="5.6.2 Obtaining Server Plugin Information">Section 5.6.2, “Obtaining Server Plugin Information”</a></dt><dd></dd><dt><a class="xref" href="mysql-cluster.html#mysql-cluster-sql-statements" title="22.5.9 Quick Reference: NDB Cluster SQL Statements">Section 22.5.9, “Quick Reference: NDB Cluster SQL Statements”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#plugins-table" title="25.21 The INFORMATION_SCHEMA PLUGINS Table">Section 25.21, “The INFORMATION_SCHEMA PLUGINS Table”</a></dt><dd></dd></dl>
</div>
<div class="indexdiv">
<h3 class="title">PROCESSLIST</h3>
<dl><dt><a class="xref" href="optimization.html#thread-information" title="8.14 Examining Thread Information">Section 8.14, “Examining Thread Information”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#kill" title="13.7.8.4 KILL Statement">Section 13.7.8.4, “KILL Statement”</a></dt><dd></dd><dt><a class="xref" href="optimization.html#explain-for-connection" title="8.8.4 Obtaining Execution Plan Information for a Named Connection">Section 8.8.4, “Obtaining Execution Plan Information for a Named Connection”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-internal-data" title="15.15.2.3 Persistence and Consistency of InnoDB Transaction and Locking Information">Section 15.15.2.3, “Persistence and Consistency of InnoDB Transaction and Locking
Information”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-processlist" title="13.7.7.29 SHOW PROCESSLIST Statement">Section 13.7.7.29, “SHOW PROCESSLIST Statement”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#clone-plugin-stop" title="5.6.7.10 Stopping a Cloning Operation">Section 5.6.7.10, “Stopping a Cloning Operation”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#innodb-trx-table" title="25.46.29 The INFORMATION_SCHEMA INNODB_TRX Table">Section 25.46.29, “The INFORMATION_SCHEMA INNODB_TRX Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#processlist-table" title="25.22 The INFORMATION_SCHEMA PROCESSLIST Table">Section 25.22, “The INFORMATION_SCHEMA PROCESSLIST Table”</a></dt><dd></dd><dt><a class="xref" href="sys-schema.html#sys-processlist" title="27.4.3.22 The processlist and x$processlist Views">Section 27.4.3.22, “The processlist and x$processlist Views”</a></dt><dd></dd><dt><a class="xref" href="performance-schema.html#threads-table" title="26.12.19.5 The threads Table">Section 26.12.19.5, “The threads Table”</a></dt><dd></dd><dt><a class="xref" href="innodb-storage-engine.html#innodb-information-schema-examples" title="15.15.2.1 Using InnoDB Transaction and Locking Information">Section 15.15.2.1, “Using InnoDB Transaction and Locking Information”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">PROFILING</h3>
<dl><dt><a class="xref" href="sql-statements.html#show-profile" title="13.7.7.30 SHOW PROFILE Statement">Section 13.7.7.30, “SHOW PROFILE Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#profiling-table" title="25.23 The INFORMATION_SCHEMA PROFILING Table">Section 25.23, “The INFORMATION_SCHEMA PROFILING Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-R"></a><h3 class="title">R</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">REFERENTIAL_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#referential-constraints-table" title="25.24 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table">Section 25.24, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#system-schema" title="5.3 The mysql System Schema">Section 5.3, “The mysql System Schema”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">RESOURCE_GROUPS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#resource-groups" title="5.1.15 Resource Groups">Section 5.1.15, “Resource Groups”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#resource-groups-table" title="25.25 The INFORMATION_SCHEMA RESOURCE_GROUPS Table">Section 25.25, “The INFORMATION_SCHEMA RESOURCE_GROUPS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ROUTINES</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#information-schema-introduction" title="25.1 Introduction">Section 25.1, “Introduction”</a></dt><dd></dd><dt><a class="xref" href="faqs.html#faqs-stored-procs" title="A.4 MySQL 8.0 FAQ: Stored Procedures and Functions">Section A.4, “MySQL 8.0 FAQ: Stored Procedures and Functions”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-procedure-status" title="13.7.7.28 SHOW PROCEDURE STATUS Statement">Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#stored-routines-metadata" title="24.2.3 Stored Routine Metadata">Section 24.2.3, “Stored Routine Metadata”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#routines-table" title="25.29 The INFORMATION_SCHEMA ROUTINES Table">Section 25.29, “The INFORMATION_SCHEMA ROUTINES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-S"></a><h3 class="title">S</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">SCHEMA_PRIVILEGES</h3>
<dl><dt><a class="xref" href="information-schema.html#schema-privileges-table" title="25.31 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table">Section 25.31, “The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">SCHEMATA</h3>
<dl><dt><a class="xref" href="security.html#grant-tables" title="6.2.3 Grant Tables">Section 6.2.3, “Grant Tables”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="security.html#privileges-provided" title="6.2.2 Privileges Provided by MySQL">Section 6.2.2, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="server-administration.html#server-system-variables" title="5.1.8 Server System Variables">Section 5.1.8, “Server System Variables”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-databases" title="13.7.7.14 SHOW DATABASES Statement">Section 13.7.7.14, “SHOW DATABASES Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#schemata-table" title="25.30 The INFORMATION_SCHEMA SCHEMATA Table">Section 25.30, “The INFORMATION_SCHEMA SCHEMATA Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_GEOMETRY_COLUMNS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#columns-table" title="25.8 The INFORMATION_SCHEMA COLUMNS Table">Section 25.8, “The INFORMATION_SCHEMA COLUMNS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#st-geometry-columns-table" title="25.33 The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table">Section 25.33, “The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_SPATIAL_REFERENCE_SYSTEMS</h3>
<dl><dt><a class="xref" href="sql-statements.html#create-spatial-reference-system" title="13.1.19 CREATE SPATIAL REFERENCE SYSTEM Statement">Section 13.1.19, “CREATE SPATIAL REFERENCE SYSTEM Statement”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="data-types.html#spatial-reference-systems" title="11.4.5 Spatial Reference System Support">Section 11.4.5, “Spatial Reference System Support”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#st-spatial-reference-systems-table" title="25.34 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table">Section 25.34, “The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">ST_UNITS_OF_MEASURE</h3>
<dl><dt><a class="xref" href="functions.html#gis-linestring-property-functions" title="12.16.7.3 LineString and MultiLineString Property Functions">Section 12.16.7.3, “LineString and MultiLineString Property Functions”</a></dt><dd></dd><dt><a class="xref" href="functions.html#spatial-relation-functions-object-shapes" title="12.16.9.1 Spatial Relation Functions That Use Object Shapes">Section 12.16.9.1, “Spatial Relation Functions That Use Object Shapes”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#st-units-of-measure-table" title="25.35 The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table">Section 25.35, “The INFORMATION_SCHEMA ST_UNITS_OF_MEASURE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">STATISTICS</h3>
<dl><dt><a class="xref" href="sql-statements.html#analyze-table" title="13.7.3.1 ANALYZE TABLE Statement">Section 13.7.3.1, “ANALYZE TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-usage-differences" title="14.7 Data Dictionary Usage Differences">Section 14.7, “Data Dictionary Usage Differences”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-index" title="13.7.7.22 SHOW INDEX Statement">Section 13.7.7.22, “SHOW INDEX Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#statistics-table" title="25.32 The INFORMATION_SCHEMA STATISTICS Table">Section 25.32, “The INFORMATION_SCHEMA STATISTICS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-T"></a><h3 class="title">T</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLE_CONSTRAINTS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#referential-constraints-table" title="25.24 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table">Section 25.24, “The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#table-constraints-table" title="25.38 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table">Section 25.38, “The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLE_PRIVILEGES</h3>
<dl><dt><a class="xref" href="information-schema.html#table-privileges-table" title="25.39 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table">Section 25.39, “The INFORMATION_SCHEMA TABLE_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLES</h3>
<dl><dt><a class="xref" href="sql-statements.html#create-table" title="13.1.20 CREATE TABLE Statement">Section 13.1.20, “CREATE TABLE Statement”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-usage-differences" title="14.7 Data Dictionary Usage Differences">Section 14.7, “Data Dictionary Usage Differences”</a></dt><dd></dd><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#information-schema-introduction" title="25.1 Introduction">Section 25.1, “Introduction”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-table-ndb-table-comment-options" title="13.1.20.10 Setting NDB_TABLE Options">Section 13.1.20.10, “Setting NDB_TABLE Options”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-table-status" title="13.7.7.36 SHOW TABLE STATUS Statement">Section 13.7.7.36, “SHOW TABLE STATUS Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-tables" title="13.7.7.37 SHOW TABLES Statement">Section 13.7.7.37, “SHOW TABLES Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#tables-table" title="25.36 The INFORMATION_SCHEMA TABLES Table">Section 25.36, “The INFORMATION_SCHEMA TABLES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TABLESPACES</h3>
<dl><dt><a class="xref" href="information-schema.html#tablespaces-table" title="25.37 The INFORMATION_SCHEMA TABLESPACES Table">Section 25.37, “The INFORMATION_SCHEMA TABLESPACES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TP_THREAD_STATE</h3>
<dl><dt><a class="xref" href="server-administration.html#thread-pool-installation" title="5.6.3.2 Thread Pool Installation">Section 5.6.3.2, “Thread Pool Installation”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">TRIGGERS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="installing.html#upgrade-prerequisites" title="2.11.5 Preparing Your Installation for Upgrade">Section 2.11.5, “Preparing Your Installation for Upgrade”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-create-trigger" title="13.7.7.11 SHOW CREATE TRIGGER Statement">Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-triggers" title="13.7.7.38 SHOW TRIGGERS Statement">Section 13.7.7.38, “SHOW TRIGGERS Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#triggers-table" title="25.40 The INFORMATION_SCHEMA TRIGGERS Table">Section 25.40, “The INFORMATION_SCHEMA TRIGGERS Table”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#trigger-metadata" title="24.3.2 Trigger Metadata">Section 24.3.2, “Trigger Metadata”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-U"></a><h3 class="title">U</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">USER_ATTRIBUTES</h3>
<dl><dt><a class="xref" href="sql-statements.html#alter-user" title="13.7.1.1 ALTER USER Statement">Section 13.7.1.1, “ALTER USER Statement”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#create-user" title="13.7.1.3 CREATE USER Statement">Section 13.7.1.3, “CREATE USER Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#user-attributes-table" title="25.41 The INFORMATION_SCHEMA USER_ATTRIBUTES Table">Section 25.41, “The INFORMATION_SCHEMA USER_ATTRIBUTES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">USER_PRIVILEGES</h3>
<dl><dt><a class="xref" href="security.html#privileges-provided" title="6.2.2 Privileges Provided by MySQL">Section 6.2.2, “Privileges Provided by MySQL”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#user-privileges-table" title="25.42 The INFORMATION_SCHEMA USER_PRIVILEGES Table">Section 25.42, “The INFORMATION_SCHEMA USER_PRIVILEGES Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<a name="is-index-V"></a><h3 class="title">V</h3>
<p>[<a class="link" href="dynindex-is.html#is-index-top">index top</a>]</p><dl><dt></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEW_ROUTINE_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#view-routine-usage-table" title="25.44 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table">Section 25.44, “The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEW_TABLE_USAGE</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#view-table-usage-table" title="25.45 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table">Section 25.45, “The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table”</a></dt><dd></dd></dl>
</div>

<div class="indexdiv">
<h3 class="title">VIEWS</h3>
<dl><dt><a class="xref" href="data-dictionary.html#data-dictionary-information-schema" title="14.5 INFORMATION_SCHEMA and Data Dictionary Integration">Section 14.5, “INFORMATION_SCHEMA and Data Dictionary Integration”</a></dt><dd></dd><dt><a class="xref" href="sql-statements.html#show-create-view" title="13.7.7.13 SHOW CREATE VIEW Statement">Section 13.7.7.13, “SHOW CREATE VIEW Statement”</a></dt><dd></dd><dt><a class="xref" href="information-schema.html#views-table" title="25.43 The INFORMATION_SCHEMA VIEWS Table">Section 25.43, “The INFORMATION_SCHEMA VIEWS Table”</a></dt><dd></dd><dt><a class="xref" href="stored-objects.html#view-metadata" title="24.5.5 View Metadata">Section 24.5.5, “View Metadata”</a></dt><dd></dd></dl>
</div>

</div>

<div class="copyright-footer">

</div>
<div class="navfooter">
<hr>
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="dynindex-function.html">Prev</a></td>
<td width="20%" align="center"><a accesskey="u" href="">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="dynindex-jointype.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top"> Function Index</td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top"> Join Types Index</td>
</tr>
</table>
</div>
</body>
</html>
